{header:([$rowcolumnname]+(.bycolumns.group|to_entries|map(.key))+["合计"])
        ,rows: (
            .data|map(.+.group|.total1=(.group|add)|del(.group)|del(.total)|del(.pinyin))
            |map(to_entries|map(.value))
        )
        ,footer: (["合计"]+
            (.bycolumns.group|to_entries|map(.value))
            |.+[(.[1:]|add)])
        }